-- 회원별 보유주식(원: 보유주 * 매입가격)
create or replace view personal_stock_sum as (select m_id, sm_code, sm_qty, sm_price * sm_qty as stock_sum from
stock_mine group by sm_code, sm_price * sm_qty, m_id, sm_qty);
-- 회원별 종목별 보유주식(원: 보유주 * 매입가격)
create or replace view personal_stock_sum_by_code as (select m_id, sm_code, sum(sm_qty) as sm_qty,
sum(stock_sum) as stock_sum from personal_stock_sum group by sm_code, m_id);
-- 회원별 전체 보유주식(원: 보유주 * 매입가격)
create or replace view personal_stock_sum_by_m_id as (select m_id, sum(stock_sum) as stock_sum from
personal_stock_sum_by_code group by m_id);
@RestController
public class StockRestController {
@Autowired
private StockDao stockDao;
// YR
@GetMapping("/addMyStock")
public String addMyStock(StockMineVO smvo, String price) {
System.
out.println(">>> addMyStock 진입 >>>");
int sm_price = Integer.
parseInt(price.replaceAll(",", ""));
smvo.setSm_price(sm_price);
int res = stockDao.addMyStock(smvo);
return res+"";
}}
SQL
Controller
회원별 보유 주식
DESCRIPTION
1. 보유주식의 코드와 매입가격으로 보유주식을
연산함
2. 쿼리가 성공적으로 수행되었을 경우 결과값을
1을 반환받아 Ajax처리